﻿CREATE PROCEDURE [dbo].[kp_DmNganhSelectAll]
AS
	SELECT 
		0 [Choice],
		[Ma_Nganh],
		T1.[Ma_Nhom],
		[Ten_Nhom],
		[Ten_Nganh],
		T1.[Ghi_Chu]
	FROM tblDmNganh T1 INNER JOIN tblDmNhomNganh T2
		ON T1.Ma_Nhom=T2.Ma_Nhom				
	Order by Ma_Nhom
RETURN 0;